package com.estun.backroundManagementService.modules.position.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.estun.backroundManagementService.modules.position.model.FeedingPort;
import com.estun.backroundManagementService.modules.product.model.Product;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface FeedingPortMapper extends BaseMapper<FeedingPort> {

    @Select("select * from t_feeding_port where id = (select feeding_port_id from material_position_relation where material_id = #{materialId} limit 1)")
    FeedingPort selectFeedingPortByMaterialId(@Param("materialId") Integer materialId);
}
